"192.168.0.1:sipop"

PRODUCTOS_AI

Descriptions

There is no desription for trigger PRODUCTOS_AI

Definition

CREATE TRIGGER PRODUCTOS_AI FOR PRODUCTOS ACTIVE
AFTER INSERT POSITION 0
AS
declare variable PADRE CHAR(13);
declare variable HIJO integer;
BEGIN
  /* Trigger body */
   
   SELECT COUNT (ID_PRODUCTOS) FROM PRODUCTOS
   WHERE
           ID_PADRE_PRODUCTO = NEW.id_padre_producto
   INTO:HIJO;
  UPDATE PRODUCTOS SET HIJOS = :HIJO WHERE ID_PRODUCTOS = new.id_padre_producto;
   

END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.